package com.annchain.og_browser.mapper;

import com.annchain.og_browser.entity.OgbTransaction;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface OgbTransactionMapper extends BaseMapper<OgbTransaction> {
    @Select("select oka.name from ogb_transaction ot " +
            "left join ogb_known_address oka on ot.from_address = oka.address " +
            "where ot.from_address=#{name} or ot.to_address=#{name}")
    Map<String,String> nameAndUrl(String name);
}
